<%@ page import="bean.load" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="bean.record" %>
<%@ page import="bean.Account" %>
<%--
  Created by IntelliJ IDEA.
  User: zhujun
  Date: 2023/1/7
  Time: 5:22
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <meta charset="utf-8">
    <title>打印预约挂号单</title>
    <link rel="stylesheet" type="text/css" href="../css/table.css">
    <link rel="stylesheet" type="text/css" href="../css/register.css">
</head>
<body>
<%
    String ur1=request.getParameter("ur1");
    load ld = new load();
    HttpSession session1=request.getSession();
    String ur=(String) session1.getAttribute("ur");
    String SQL = "select*from reg where id='"+ur+"' and doc_id='"+ur1+"'";
    ArrayList<record> ar = ld.loadrecord(SQL);
    String SQL1 = "select*from act where id='"+ur+"'";
    ArrayList<Account> ar1 = ld.loadact(SQL1);
%>
<h2>预约挂号打印</h2>
<h3>编号:<%=ar.get(0).getRec_id()%></h3>
<h3>用户名:<%=ar.get(0).getId()%></h3>
<h3>主治医生编号:<%=ar.get(0).getDoc_id()%></h3>
<h3>姓名:<%=ar1.get(0).getName()%></h3>
<h3>性别:<%=ar1.get(0).getSex()%></h3>
<h3>邮箱:<%=ar1.get(0).getEmail()%></h3>
<h3>电话:<%=ar1.get(0).getPhone()%></h3>
<h3>地址:<%=ar1.get(0).getAddress()%></h3>
<h3>预约时间:<%=ar.get(0).getRec_time()%></h3>
</body>
</html>
